/*
Navicat SQL Server Data Transfer

Source Server         : Balder@UCN
Source Server Version : 105000
Source Host           : Balder.ucn.dk:1433
Source Database       : dmaa0912_E7
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2013-10-09 13:58:47
*/


-- ----------------------------
-- Table structure for User
-- ----------------------------
DROP TABLE [dbo].[User]
GO
CREATE TABLE [dbo].[User] (
[Id] int NOT NULL IDENTITY(1,1),
[Email] varchar(100) NOT NULL ,
[LastName] varchar(55) NOT NULL ,
[FirstName] varchar(55) NOT NULL ,
[Address] varchar(80) NULL ,
[City] varchar(40) NULL ,
[ZipCode] int NULL ,
[PhoneNumber] int NOT NULL ,
[PassCode] varchar(60) NOT NULL 
)


GO

-- ----------------------------
-- Indexes structure for table User
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table User
-- ----------------------------
ALTER TABLE [dbo].[User] ADD PRIMARY KEY ([Id])
GO
